Heather Duff
Heather Duff
Reactions
-
Re: extract part of a cell's text
@Paul Newcome As always, thank you for this - I was looking for a formula to pull only the text to the right of a character. I'm so thankful that you already had it written out for me!1 · -
Re: formula to show fiscal year
Hi Katie, Try this, where [Pub Date] is the publication date column. This assumes that your FY running from July 2020-June 2021 is FY21. =IF(MONTH([Pub Date]@row) > 6, YEAR([Pub Date]@row) + 1, YE…2 · -
Re: Help converting an Excel function
@Steve Cribbs I'm not 100% sure I follow exactly what you want, but I think I may be headed in the right direction (it's just way different from what your formula looks like: =IF(COUNTIF($AF$6:$AF$18…1 · -
Re: Date Range Formula
Hi @Diego V , Have you tried creating a report and adding a report widget to your dashboard? Reports have great filter capabilities!1 · -
Re: Combined Update request across multiple projects/sheets
Hi @tariq.shaikh@signspecialists.com , Have you considered using the scheduled "send as attachment" option on the report to remind people daily to make updates? It's not necessarily an upda…2 ·
